Search results 59

  2. Search results
  3. pivot table
Card image cap
ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Apr3
Card image cap
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14
Card image cap
VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

Jan26
Card image cap
PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Jan23
Card image cap
PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

Jan22
Card image cap
SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20
Card image cap
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22
Card image cap
ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17
Card image cap
SearchinHTMLTable

Search for a word in a certain column in html table and return the full row ...

2023Nov12
Card image cap
ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13
Card image cap
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28
Card image cap
ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

2023Aug13